Lookup example
The following example shows how a lookup table is used to concatenate a Dutch translation of the category name (located in the lookup table) to the original category name located in the landing table.
The lookup could be defined using the following expressions:
-
Condition expression: ${Lookup.CategoryID}=${Landing.CategoryID}
Meaning: Perform the lookup only if the Category ID in the landing table and the lookup table are the same.
-
Result column expression: ${Lookup.CategoryName} + ’is’ + ${Landing.CategoryName}
Meaning: Add the data in the CategoryName column in the lookup table to the data in the CategoryName column in the landing table (separated by the word "is").
Example:
Assuming the result column name is "Split Name", clicking the Preview Results button would display the following table:
| Split Name | Category Name (Lookup) | Category Name (Landing) | Category ID (Lookup) | Category ID (Landing) |
|---|---|---|---|---|
|
dranken is Beverages |
dranken |
Beverages |
1 |
1 |
|
Specerijen is Condiments |
Specerijen |
Condiments |
2 |
2 |
|
Gebak is Confectionary |
Gebak |
Confectionary |
3 |
3 |
|
Zuivelproducten is Dairy Products |
Zuivelproducten |
Dairy Products |
4 |
4 |
|
Grains/Granen is Grains/Cereal |
Grains/Granen |
Grains/Cereal |
5 |
5 |
|
Vlees/Gevolgete is Meat/Poultry |
Vlees/Gevolgete |
Meat/Poultry |
6 |
6 |